UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4hKQlTc7M9/lxHhLN4vpqzWgkiO1QtVbOkIQN6kFdRU='
WHERE
key_id = '8c3bfb9c8b662b0f687ba357816ad0ef05ae952cd0b2ed43db4151eb933f43ee'
AND (
token = '4hKQlTc7M9/lxHhLN4vpqzWgkiO1QtVbOkIQN6kFdRU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)