UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'I0TwY9MZdTgEiBVRnMwDI9iabbsrRot+9u3JhTtGG/A='
WHERE
key_id = '6331666f0cf0a3b47bfc240a28ce9c42f68f49140bc5001a73548eed440c7efe'
AND (
token = 'I0TwY9MZdTgEiBVRnMwDI9iabbsrRot+9u3JhTtGG/A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)