UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'GGQDdQBCxbqtHtbcmRo3CmRr3TnBimj2Nncf7e/R6ds=' 
WHERE 
  key_id = '6ac2c67cfbf292bc8718380fbfd1e0d739fa6f947f4b4fc1175d04f0e5a36ede' 
  AND (
    token = 'GGQDdQBCxbqtHtbcmRo3CmRr3TnBimj2Nncf7e/R6ds=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00071