UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZpksgDPuE4zUa9Yt7rHH6YYwleKkH5k8fArpZb6vO8s='
WHERE
key_id = '13c7a30f387fd38147026d19b39ed8982c883722dc04a2edc18ab59251f802cc'
AND (
token = 'ZpksgDPuE4zUa9Yt7rHH6YYwleKkH5k8fArpZb6vO8s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)