UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 's7zbAIAfw7tveneHISwlyfgqx5/8BfsrfhpwxzJHMCA='
WHERE
key_id = '1c78655047bd028a6a916c34bf28e095f21677c4d2e87153de73b30e65fbf360'
AND (
token = 's7zbAIAfw7tveneHISwlyfgqx5/8BfsrfhpwxzJHMCA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)