UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dtydPjnG8SduKFQyJ8khP6s9y/p+mHykjOjx0nV3Vso='
WHERE
key_id = 'ca82aa4abef0bfde8a7a997ede29518038ca70381de2bf46e80d32e9dfda2871'
AND (
token = 'dtydPjnG8SduKFQyJ8khP6s9y/p+mHykjOjx0nV3Vso='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)