UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Cai3gCoGWlU+m89/TtLwhOVfK/1YKX9WFpM6aPnmrr8=' 
WHERE 
  key_id = '5e296ec13d34bf19344b9b33b7c2c4da25d9b27b2e4559c1b27d4cccac2bc1eb' 
  AND (
    token = 'Cai3gCoGWlU+m89/TtLwhOVfK/1YKX9WFpM6aPnmrr8=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00013