UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'EfGcyk/sgt7Zk6vOBtU3Wlq1xeeg6wex/vb+zQKvSf4=' 
WHERE 
  key_id = 'b885e16e3e5f1000f535ce86b626078eba106442f792093e2144f5ba6b854722' 
  AND (
    token = 'EfGcyk/sgt7Zk6vOBtU3Wlq1xeeg6wex/vb+zQKvSf4=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022