UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'ByJactzm3kym+/AMc8ZyXPCf+lteId/4zpgUuj25+xs=' 
WHERE 
  key_id = 'eb40c390e4cd99e7c329d6057c62ade22bcb4d15f9602a19140009a537d8735c' 
  AND (
    token = 'ByJactzm3kym+/AMc8ZyXPCf+lteId/4zpgUuj25+xs=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00023