UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GNzm9W7x3zfCZ/RqQWUtWQ2e4vnckJQv/ruebrRjC38='
WHERE
key_id = 'f648d1f64515898befbb596d56c18f65f566aa8dc1253ce0b83f096430a3b5c9'
AND (
token = 'GNzm9W7x3zfCZ/RqQWUtWQ2e4vnckJQv/ruebrRjC38='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)