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