UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'EkIZ1mynaxuZHDiTbpT2Q1Lm9L64WSa1jqCQgw2T7qE=' 
WHERE 
  key_id = 'c2767514a30e1eba14dc84e4a0852c874b61a5e9006e67a18803b100d244d4c1' 
  AND (
    token = 'EkIZ1mynaxuZHDiTbpT2Q1Lm9L64WSa1jqCQgw2T7qE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00055