UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pt6X/qXBEcbPOhOTNxN0SL3Eln3daHYq2G4h4kA6gGI='
WHERE
key_id = 'd724987438e62d0f43ee5b627f63cb21372f2fc17c23d517b3591e8c9640120e'
AND (
token = 'pt6X/qXBEcbPOhOTNxN0SL3Eln3daHYq2G4h4kA6gGI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)