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