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