UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XbYfCncOvesOBozB9AOKYG8Go6xKV007Vjx8eFrIZ1E='
WHERE
key_id = '02ac9460c3cbe21d860d0988c51436b43b689486a6a257f1a06e82168015c7c1'
AND (
token = 'XbYfCncOvesOBozB9AOKYG8Go6xKV007Vjx8eFrIZ1E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)