UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'q1bb+HoFJAAes89YVsB4zF5yyMqd8ZHe9YKGAL+ptsY='
WHERE
key_id = 'f026ed10c45b9c0bdeb36b6c90cf3e33fd68eda2e91e8cf41aa2f2090b37ce32'
AND (
token = 'q1bb+HoFJAAes89YVsB4zF5yyMqd8ZHe9YKGAL+ptsY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)