UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fJlkkOaQTwp0fFCcljkunA1ooa4S7Sebori2+aohyew='
WHERE
key_id = 'ae245bd5aca6aad92b584d1acaa808590059dbb73cf0400c13cdc9cc12038144'
AND (
token = 'fJlkkOaQTwp0fFCcljkunA1ooa4S7Sebori2+aohyew='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)