UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Ozf9cH1VnEfoCNmvJ/KmPNv7DA+CBH+Ugy820VxjUoU=' 
WHERE 
  key_id = 'cdfcfe71653abab06f90762b8fc2ce2aaf924440757b94b03f37a2507a884c0d' 
  AND (
    token = 'Ozf9cH1VnEfoCNmvJ/KmPNv7DA+CBH+Ugy820VxjUoU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00024