UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8tKey38q4Z8F6pdrwWYl4VCCHzlJV6hX/K9q1WR+XXw='
WHERE
key_id = '9436f015ef93a02b81aa71ecaeb1b27058b126ab35832844dca14b47d942bc18'
AND (
token = '8tKey38q4Z8F6pdrwWYl4VCCHzlJV6hX/K9q1WR+XXw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)