UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'S0IrFIze1TG9Qy9oIsNdrjHlYDwySd6WNebwk4ZR9g4='
WHERE
key_id = 'afa3988c7984b8983068cc92d53c442fa519dbf5e69842c64ca7111508ad2a8f'
AND (
token = 'S0IrFIze1TG9Qy9oIsNdrjHlYDwySd6WNebwk4ZR9g4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)