UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gF7OFOtffTD7ALgY7YHnWgFLTySJjIYc0vELFHDBbFA='
WHERE
key_id = '4963fc70f12639e67c27b9115be8317db09dd6f86032b1744a7184fbdccd91a0'
AND (
token = 'gF7OFOtffTD7ALgY7YHnWgFLTySJjIYc0vELFHDBbFA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)