UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KWNC1ZqVFzZvdKJUoHPbebglJj7qwxyKCdISwMG9egg='
WHERE
key_id = '57961872b8b9b60064cf89af98fce54ae8baa939ebb332bfdbffecc6ce0abb46'
AND (
token = 'KWNC1ZqVFzZvdKJUoHPbebglJj7qwxyKCdISwMG9egg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)