UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '58IofL2+VmN5cSv/a6DPB1ePcCY6ADgspAvrfAExakw='
WHERE
key_id = 'f1477ca8622d7472196eda59d6f0c5b167e15c67de4e7603b5857088c46fb812'
AND (
token = '58IofL2+VmN5cSv/a6DPB1ePcCY6ADgspAvrfAExakw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)