UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QOzU5OgaCHqSNzzdqOiti6qYiCNLRFnws2LpYYRFKbo='
WHERE
key_id = 'a71e2c837b70a3cd632fd1ec237386082934c31ed98c1c456c25522bb57541ae'
AND (
token = 'QOzU5OgaCHqSNzzdqOiti6qYiCNLRFnws2LpYYRFKbo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)