UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rmzw0pYNo1BUhM/J4xYNMkHkCrzXc5xPzOMDo8tHOvw='
WHERE
key_id = '8a120f2230c194c7a4165b66b467920040ba2b7d90263da28f0f74828964e001'
AND (
token = 'rmzw0pYNo1BUhM/J4xYNMkHkCrzXc5xPzOMDo8tHOvw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)