UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zsG2ppADnNynDXxCKDiJGe8xBVTBObR1eWoIRDl1eYM='
WHERE
key_id = 'ca256e7846de4bd72f856af37a1069ce7b570aa1470415eb864170d5ba34895d'
AND (
token = 'zsG2ppADnNynDXxCKDiJGe8xBVTBObR1eWoIRDl1eYM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)