UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1hW6aJ3SBC98wUT50BeNWAXtOqh6EMTCCIXGNPpti5s='
WHERE
key_id = '0b0f74c6afeee623e935f6e8df4b6800adffda54357071b46dfe9a4a1062f313'
AND (
token = '1hW6aJ3SBC98wUT50BeNWAXtOqh6EMTCCIXGNPpti5s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)