UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '15lVjDjqP/+Ls6CG4Jlw35suusugE19bF0APAvKdtkg=' 
WHERE 
  key_id = '8b733ad1b3548632db1dd587162745a2865601e403a1397184a99504d0e8a588' 
  AND (
    token = '15lVjDjqP/+Ls6CG4Jlw35suusugE19bF0APAvKdtkg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00035