UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '5/2YDJ2nHvPuE+tmH6nnP42n6ZuVLNCCF9gch8aKDTs=' 
WHERE 
  key_id = '78a595d905e08de4406068cec2b9dd75f1f9c38bb45ad76e88ba0f48029c3329' 
  AND (
    token = '5/2YDJ2nHvPuE+tmH6nnP42n6ZuVLNCCF9gch8aKDTs=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00034