UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7SYnOYZr2DdW3ye1FBaG6Hh2+HJOqsL2vP0bG1y7RIw='
WHERE
key_id = '63f39ccfe53bd2c4d6ebc47124feabadd29d62b4ef170215a6b349ae5a1a6a9f'
AND (
token = '7SYnOYZr2DdW3ye1FBaG6Hh2+HJOqsL2vP0bG1y7RIw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)