UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Wth9sF4yVPfJKjHaZzTuIFP2lEfk1hfEPyuoqODVwTU=' 
WHERE 
  key_id = '2d7840fc9e477c6e07fb83dcf9b22bb391760bc1ae9ca42ec13e5f9bfb973a7e' 
  AND (
    token = 'Wth9sF4yVPfJKjHaZzTuIFP2lEfk1hfEPyuoqODVwTU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00044