UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '8FaeiOBvth+JH+YRbKFV4ZDrAgdpnKJdv6WUbW8+Pxg=' 
WHERE 
  key_id = '3f3679035167743a160c05d07d6ff98e874819e8c9a0e5fdbe0eae5f3eade69b' 
  AND (
    token = '8FaeiOBvth+JH+YRbKFV4ZDrAgdpnKJdv6WUbW8+Pxg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00042