UPDATE 
  cscart_june_setuplock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'gXhbuEqOufTlcKreHGy9NbAKKrkFxGEq0l9bqbX7zHA=' 
WHERE 
  key_id = '8ab5d947f4bc62b0fb484f6d1ca6c7dc95b3c5f8544921e363f231a042711d99' 
  AND (
    token = 'gXhbuEqOufTlcKreHGy9NbAKKrkFxGEq0l9bqbX7zHA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021