UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '2h3o0Qt95/cPF0zUfxQ6OiG2Ih4jo0sfscihRP9vfIg=' 
WHERE 
  key_id = '9622acc26d9cd366bc1c3e6b7a42b6f208cc050f421b5d1c7c2735df469cee84' 
  AND (
    token = '2h3o0Qt95/cPF0zUfxQ6OiG2Ih4jo0sfscihRP9vfIg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00040