UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KylVCyPj1FzbEtGpBy+NXOyi8vsucnkW/g87MaXx1/I='
WHERE
key_id = '2a3b5c2549f69ead89df37cb94fe857543ff2dafa92f5706f9b403f4616fcfa3'
AND (
token = 'KylVCyPj1FzbEtGpBy+NXOyi8vsucnkW/g87MaXx1/I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)