UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+vTaL7wRlT1xPcpJn94tiOhCkTBup9Ppui0K6DvFCu8='
WHERE
key_id = '7c4722341018d7c28edae52922c9f704b668193cf547f1931074f9de2ed955a5'
AND (
token = '+vTaL7wRlT1xPcpJn94tiOhCkTBup9Ppui0K6DvFCu8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)