UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qd9GzT+btIbJZaQiFTxLPpK1jZedrlcJZ9cCUc33GIs='
WHERE
key_id = 'd19891918fa70071997f0f88f839dfb17419676976e6f01186ca11ef250c5c39'
AND (
token = 'qd9GzT+btIbJZaQiFTxLPpK1jZedrlcJZ9cCUc33GIs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)