UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cfiI3txdFv5AB4f0KWOqC9sGk/0vcool1vTCXET0yRs='
WHERE
key_id = 'e272befe28b4cb018521204d5d52196cfd2d45c5a7bb151dacd36deb4b35efb9'
AND (
token = 'cfiI3txdFv5AB4f0KWOqC9sGk/0vcool1vTCXET0yRs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)